This script takes the raw outputs from the water quality sensors at Carvins Cove combines them into one file, identifies gaps in the data, runs the data through the QAQC function (qaqc_ccrwq), and produces QAQC plots for visual inspection.

  1. Open the script and check you have the correct function in line 19
  2. Change the current start and end times to match the year you are publishing for
  3. If there are more than one csv make sure they are all in the Download data chunk. Currently there is only one csv with all of the observations.
  4. Once you have made sure everything is up to date press the knit button and it will produce an html file with all of the outputs and plots.

Check for gaps in the data frame

This identifies if there are any daily data gaps in the long-term record

This identifies if there are any sub-daily gaps in the long-term record. Most of these gaps happen when we change the program on the data logger.

## [1] "2021-07-02 14:00:00 UTC" "2021-07-02 14:50:00 UTC"
## [1] "2022-04-05 12:00:00 UTC" "2022-04-05 14:00:00 UTC"
## [1] "2022-04-20 13:00:00 UTC" "2022-04-20 13:40:00 UTC"
## [1] "2022-04-20 14:00:00 UTC" "2022-04-20 15:00:00 UTC"
## [1] "2022-05-12 10:00:00 UTC" "2022-05-12 10:30:00 UTC"
## [1] "2022-09-29 14:00:00 UTC" "2022-09-29 15:00:00 UTC"
## [1] "2022-10-17 17:30:00 UTC" "2022-10-17 18:10:00 UTC"
## [1] "2023-01-24 16:00:00 UTC" "2023-01-24 16:50:00 UTC"
## [1] "2023-02-28 12:10:00 UTC" "2023-02-28 12:20:00 UTC"

Read in the QAQC File and Check it out

This section reads in the QAQC file and then you can look at the head, tail and structure. Make sure the last row is Dec. 31 23:50 of the publishing year. There should be 97 columns unless a new column has been added.

## Rows: 90882 Columns: 97
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr   (1): Reservoir
## dbl  (95): Site, ThermistorTemp_C_1, ThermistorTemp_C_2, ThermistorTemp_C_3,...
## dttm  (1): DateTime
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## # A tibble: 6 × 97
##   Reservoir  Site DateTime            Thermist…¹ Therm…² Therm…³ Therm…⁴ Therm…⁵
##   <chr>     <dbl> <dttm>                   <dbl>   <dbl>   <dbl>   <dbl>   <dbl>
## 1 CCR          51 2021-04-09 15:20:00         NA      NA      NA      NA      NA
## 2 CCR          51 2021-04-09 15:30:00         NA      NA      NA      NA      NA
## 3 CCR          51 2021-04-09 15:40:00         NA      NA      NA      NA      NA
## 4 CCR          51 2021-04-09 15:50:00         NA      NA      NA      NA      NA
## 5 CCR          51 2021-04-09 16:00:00         NA      NA      NA      NA      NA
## 6 CCR          51 2021-04-09 16:10:00         NA      NA      NA      NA      NA
## # … with 89 more variables: ThermistorTemp_C_6 <dbl>, ThermistorTemp_C_7 <dbl>,
## #   ThermistorTemp_C_8 <dbl>, ThermistorTemp_C_9 <dbl>,
## #   ThermistorTemp_C_10 <dbl>, ThermistorTemp_C_11 <dbl>,
## #   ThermistorTemp_C_12 <dbl>, ThermistorTemp_C_13 <dbl>, EXOTemp_C_1 <dbl>,
## #   EXOCond_uScm_1 <dbl>, EXOSpCond_uScm_1 <dbl>, EXOTDS_mgL_1 <dbl>,
## #   EXODOsat_percent_1 <dbl>, EXODO_mgL_1 <dbl>, EXOChla_RFU_1 <dbl>,
## #   EXOChla_ugL_1 <dbl>, EXOBGAPC_RFU_1 <dbl>, EXOBGAPC_ugL_1 <dbl>, …
## # A tibble: 6 × 97
##   Reservoir  Site DateTime            Thermist…¹ Therm…² Therm…³ Therm…⁴ Therm…⁵
##   <chr>     <dbl> <dttm>                   <dbl>   <dbl>   <dbl>   <dbl>   <dbl>
## 1 CCR          51 2022-12-31 23:00:00       5.72    5.44    5.35    5.34    5.30
## 2 CCR          51 2022-12-31 23:10:00       5.71    5.47    5.42    5.35    5.32
## 3 CCR          51 2022-12-31 23:20:00       5.71    5.56    5.42    5.36    5.33
## 4 CCR          51 2022-12-31 23:30:00       5.71    5.59    5.40    5.35    5.32
## 5 CCR          51 2022-12-31 23:40:00       5.71    5.60    5.43    5.35    5.32
## 6 CCR          51 2022-12-31 23:50:00       5.69    5.66    5.38    5.35    5.31
## # … with 89 more variables: ThermistorTemp_C_6 <dbl>, ThermistorTemp_C_7 <dbl>,
## #   ThermistorTemp_C_8 <dbl>, ThermistorTemp_C_9 <dbl>,
## #   ThermistorTemp_C_10 <dbl>, ThermistorTemp_C_11 <dbl>,
## #   ThermistorTemp_C_12 <dbl>, ThermistorTemp_C_13 <dbl>, EXOTemp_C_1 <dbl>,
## #   EXOCond_uScm_1 <dbl>, EXOSpCond_uScm_1 <dbl>, EXOTDS_mgL_1 <dbl>,
## #   EXODOsat_percent_1 <dbl>, EXODO_mgL_1 <dbl>, EXOChla_RFU_1 <dbl>,
## #   EXOChla_ugL_1 <dbl>, EXOBGAPC_RFU_1 <dbl>, EXOBGAPC_ugL_1 <dbl>, …
## spc_tbl_ [90,882 × 97] (S3: spec_tbl_df/tbl_df/tbl/data.frame)
##  $ Reservoir               : chr [1:90882] "CCR" "CCR" "CCR" "CCR" ...
##  $ Site                    : num [1:90882] 51 51 51 51 51 51 51 51 51 51 ...
##  $ DateTime                : POSIXct[1:90882], format: "2021-04-09 15:20:00" "2021-04-09 15:30:00" ...
##  $ ThermistorTemp_C_1      : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ ThermistorTemp_C_2      : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ ThermistorTemp_C_3      : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ ThermistorTemp_C_4      : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ ThermistorTemp_C_5      : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ ThermistorTemp_C_6      : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ ThermistorTemp_C_7      : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ ThermistorTemp_C_8      : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ ThermistorTemp_C_9      : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ ThermistorTemp_C_10     : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ ThermistorTemp_C_11     : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ ThermistorTemp_C_12     : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ ThermistorTemp_C_13     : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXOTemp_C_1             : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXOCond_uScm_1          : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXOSpCond_uScm_1        : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXOTDS_mgL_1            : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXODOsat_percent_1      : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXODO_mgL_1             : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXOChla_RFU_1           : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXOChla_ugL_1           : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXOBGAPC_RFU_1          : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXOBGAPC_ugL_1          : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXOfDOM_RFU_1           : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXOfDOM_QSU_1           : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXOPressure_psi_1       : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXODepth_m_1            : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXOBattery_V_1          : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXOCablepower_V_1       : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXOWiper_V_1            : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ EXOTemp_C_9             : num [1:90882] 8.54 8.39 8.47 8.42 8.4 ...
##  $ EXOCond_uScm_9          : num [1:90882] 35.2 35.2 35.2 35.2 35.2 ...
##  $ EXOSpCond_uScm_9        : num [1:90882] 51.4 51.5 51.5 51.5 51.5 ...
##  $ EXOTDS_mgL_9            : num [1:90882] 33.4 33.5 33.5 33.5 33.5 ...
##  $ EXODOsat_percent_9      : num [1:90882] 87.8 87.2 87.3 86.8 87.3 ...
##  $ EXODO_mgL_9             : num [1:90882] 10.3 10.2 10.2 10.2 10.2 ...
##  $ EXOfDOM_RFU_9           : num [1:90882] 5.42 5.42 5.41 5.41 5.42 5.42 5.42 5.41 5.42 5.42 ...
##  $ EXOfDOM_QSU_9           : num [1:90882] 16.5 16.5 16.4 16.4 16.5 ...
##  $ EXOPressure_psi_9       : num [1:90882] 12.8 12.8 12.8 12.8 12.8 ...
##  $ EXODepth_m_9            : num [1:90882] 9 9 8.99 9 9 ...
##  $ EXOBattery_V_9          : num [1:90882] 3.12 3.12 3.12 3.12 3.12 3.12 3.12 3.12 3.12 3.12 ...
##  $ EXOCablepower_V_9       : num [1:90882] 12.1 12.1 12.1 12.1 12.1 ...
##  $ EXOWiper_V_9            : num [1:90882] 1.19 1.19 1.19 1.2 1.2 1.2 1.19 1.19 1.2 1.19 ...
##  $ LvlPressure_psi_13      : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ LvlDepth_m_13           : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ LvlTemp_C_13            : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
##  $ RECORD                  : num [1:90882] 8 9 10 11 12 13 14 15 16 17 ...
##  $ CR3000Battery_V         : num [1:90882] 13 13 12.9 12.9 12.9 ...
##  $ CR3000Panel_Temp_C      : num [1:90882] 20.9 21.1 21.2 21.4 21.4 ...
##  $ Flag_ThermistorTemp_C_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_ThermistorTemp_C_2 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_ThermistorTemp_C_3 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_ThermistorTemp_C_4 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_ThermistorTemp_C_5 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_ThermistorTemp_C_6 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_ThermistorTemp_C_7 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_ThermistorTemp_C_8 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_ThermistorTemp_C_9 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_ThermistorTemp_C_10: num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_ThermistorTemp_C_11: num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_ThermistorTemp_C_12: num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_ThermistorTemp_C_13: num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXOTemp_C_1        : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXOCond_uScm_1     : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXOSpCond_uScm_1   : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXOTDS_mgL_1       : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXODOsat_percent_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXODO_mgL_1        : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXOChla_RFU_1      : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXOChla_ugL_1      : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXOBGAPC_RFU_1     : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXOBGAPC_ugL_1     : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXOfDOM_RFU_1      : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXOfDOM_QSU_1      : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXOPressure_psi_1  : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXODepth_m_1       : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXOBattery_V_1     : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXOCablepower_V_1  : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXOWiper_V_1       : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_EXOTemp_C_9        : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
##  $ Flag_EXOCond_uScm_9     : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
##  $ Flag_EXOSpCond_uScm_9   : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
##  $ Flag_EXOTDS_mgL_9       : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
##  $ Flag_EXODOsat_percent_9 : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
##  $ Flag_EXODO_mgL_9        : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
##  $ Flag_EXOfDOM_RFU_9      : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
##  $ Flag_EXOfDOM_QSU_9      : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
##  $ Flag_EXOPressure_psi_9  : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
##  $ Flag_EXODepth_m_9       : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
##  $ Flag_EXOBattery_V_9     : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
##  $ Flag_EXOCablepower_V_9  : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
##  $ Flag_EXOWiper_V_9       : num [1:90882] 1 1 1 1 1 1 1 1 1 1 ...
##  $ Flag_LvlPressure_psi_13 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  $ Flag_LvlTemp_C_13       : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
##  - attr(*, "spec")=
##   .. cols(
##   ..   Reservoir = col_character(),
##   ..   Site = col_double(),
##   ..   DateTime = col_datetime(format = ""),
##   ..   ThermistorTemp_C_1 = col_double(),
##   ..   ThermistorTemp_C_2 = col_double(),
##   ..   ThermistorTemp_C_3 = col_double(),
##   ..   ThermistorTemp_C_4 = col_double(),
##   ..   ThermistorTemp_C_5 = col_double(),
##   ..   ThermistorTemp_C_6 = col_double(),
##   ..   ThermistorTemp_C_7 = col_double(),
##   ..   ThermistorTemp_C_8 = col_double(),
##   ..   ThermistorTemp_C_9 = col_double(),
##   ..   ThermistorTemp_C_10 = col_double(),
##   ..   ThermistorTemp_C_11 = col_double(),
##   ..   ThermistorTemp_C_12 = col_double(),
##   ..   ThermistorTemp_C_13 = col_double(),
##   ..   EXOTemp_C_1 = col_double(),
##   ..   EXOCond_uScm_1 = col_double(),
##   ..   EXOSpCond_uScm_1 = col_double(),
##   ..   EXOTDS_mgL_1 = col_double(),
##   ..   EXODOsat_percent_1 = col_double(),
##   ..   EXODO_mgL_1 = col_double(),
##   ..   EXOChla_RFU_1 = col_double(),
##   ..   EXOChla_ugL_1 = col_double(),
##   ..   EXOBGAPC_RFU_1 = col_double(),
##   ..   EXOBGAPC_ugL_1 = col_double(),
##   ..   EXOfDOM_RFU_1 = col_double(),
##   ..   EXOfDOM_QSU_1 = col_double(),
##   ..   EXOPressure_psi_1 = col_double(),
##   ..   EXODepth_m_1 = col_double(),
##   ..   EXOBattery_V_1 = col_double(),
##   ..   EXOCablepower_V_1 = col_double(),
##   ..   EXOWiper_V_1 = col_double(),
##   ..   EXOTemp_C_9 = col_double(),
##   ..   EXOCond_uScm_9 = col_double(),
##   ..   EXOSpCond_uScm_9 = col_double(),
##   ..   EXOTDS_mgL_9 = col_double(),
##   ..   EXODOsat_percent_9 = col_double(),
##   ..   EXODO_mgL_9 = col_double(),
##   ..   EXOfDOM_RFU_9 = col_double(),
##   ..   EXOfDOM_QSU_9 = col_double(),
##   ..   EXOPressure_psi_9 = col_double(),
##   ..   EXODepth_m_9 = col_double(),
##   ..   EXOBattery_V_9 = col_double(),
##   ..   EXOCablepower_V_9 = col_double(),
##   ..   EXOWiper_V_9 = col_double(),
##   ..   LvlPressure_psi_13 = col_double(),
##   ..   LvlDepth_m_13 = col_double(),
##   ..   LvlTemp_C_13 = col_double(),
##   ..   RECORD = col_double(),
##   ..   CR3000Battery_V = col_double(),
##   ..   CR3000Panel_Temp_C = col_double(),
##   ..   Flag_ThermistorTemp_C_1 = col_double(),
##   ..   Flag_ThermistorTemp_C_2 = col_double(),
##   ..   Flag_ThermistorTemp_C_3 = col_double(),
##   ..   Flag_ThermistorTemp_C_4 = col_double(),
##   ..   Flag_ThermistorTemp_C_5 = col_double(),
##   ..   Flag_ThermistorTemp_C_6 = col_double(),
##   ..   Flag_ThermistorTemp_C_7 = col_double(),
##   ..   Flag_ThermistorTemp_C_8 = col_double(),
##   ..   Flag_ThermistorTemp_C_9 = col_double(),
##   ..   Flag_ThermistorTemp_C_10 = col_double(),
##   ..   Flag_ThermistorTemp_C_11 = col_double(),
##   ..   Flag_ThermistorTemp_C_12 = col_double(),
##   ..   Flag_ThermistorTemp_C_13 = col_double(),
##   ..   Flag_EXOTemp_C_1 = col_double(),
##   ..   Flag_EXOCond_uScm_1 = col_double(),
##   ..   Flag_EXOSpCond_uScm_1 = col_double(),
##   ..   Flag_EXOTDS_mgL_1 = col_double(),
##   ..   Flag_EXODOsat_percent_1 = col_double(),
##   ..   Flag_EXODO_mgL_1 = col_double(),
##   ..   Flag_EXOChla_RFU_1 = col_double(),
##   ..   Flag_EXOChla_ugL_1 = col_double(),
##   ..   Flag_EXOBGAPC_RFU_1 = col_double(),
##   ..   Flag_EXOBGAPC_ugL_1 = col_double(),
##   ..   Flag_EXOfDOM_RFU_1 = col_double(),
##   ..   Flag_EXOfDOM_QSU_1 = col_double(),
##   ..   Flag_EXOPressure_psi_1 = col_double(),
##   ..   Flag_EXODepth_m_1 = col_double(),
##   ..   Flag_EXOBattery_V_1 = col_double(),
##   ..   Flag_EXOCablepower_V_1 = col_double(),
##   ..   Flag_EXOWiper_V_1 = col_double(),
##   ..   Flag_EXOTemp_C_9 = col_double(),
##   ..   Flag_EXOCond_uScm_9 = col_double(),
##   ..   Flag_EXOSpCond_uScm_9 = col_double(),
##   ..   Flag_EXOTDS_mgL_9 = col_double(),
##   ..   Flag_EXODOsat_percent_9 = col_double(),
##   ..   Flag_EXODO_mgL_9 = col_double(),
##   ..   Flag_EXOfDOM_RFU_9 = col_double(),
##   ..   Flag_EXOfDOM_QSU_9 = col_double(),
##   ..   Flag_EXOPressure_psi_9 = col_double(),
##   ..   Flag_EXODepth_m_9 = col_double(),
##   ..   Flag_EXOBattery_V_9 = col_double(),
##   ..   Flag_EXOCablepower_V_9 = col_double(),
##   ..   Flag_EXOWiper_V_9 = col_double(),
##   ..   Flag_LvlPressure_psi_13 = col_double(),
##   ..   Flag_LvlTemp_C_13 = col_double()
##   .. )
##  - attr(*, "problems")=<externalptr>

Flag Frequency

Let’s look at the flag Frequency for each variable. As a reminder here are the flag codes Flag values:

0: no flag

1: value removed due to maintenance and set to NA

2: negative or outlier value removed and set to NA, see Methods section for more detail on QAQC process

3: negative values set to 0

4: value removed due to fouling and set to NA

5: questionable value due to potential fouling

6: Values adjusted using a linear or square root function

7: missing data

8: Value corrected using a constant offset due to two thermistor malfunctions in Fall 2020

## Flag_ThermistorTemp_C_1
##     0     2     7  <NA> 
## 24536 61715  4631     0 
## Flag_ThermistorTemp_C_2
##     0     2     7  <NA> 
## 73819 12432  4631     0 
## Flag_ThermistorTemp_C_3
##     0     7  <NA> 
## 86251  4631     0 
## Flag_ThermistorTemp_C_4
##     0     7  <NA> 
## 86251  4631     0 
## Flag_ThermistorTemp_C_5
##     0     7  <NA> 
## 86251  4631     0 
## Flag_ThermistorTemp_C_6
##     0     7  <NA> 
## 86250  4632     0 
## Flag_ThermistorTemp_C_7
##     0     7  <NA> 
## 86250  4632     0 
## Flag_ThermistorTemp_C_8
##     0     7  <NA> 
## 86247  4635     0 
## Flag_ThermistorTemp_C_9
##     0     7  <NA> 
## 86250  4632     0 
## Flag_ThermistorTemp_C_10
##     0     7  <NA> 
## 86246  4636     0 
## Flag_ThermistorTemp_C_11
##     0     7  <NA> 
## 86251  4631     0 
## Flag_ThermistorTemp_C_12
##     0     7  <NA> 
## 86250  4632     0 
## Flag_ThermistorTemp_C_13
##     0     1     7  <NA> 
## 83408  2843  4631     0 
## Flag_EXOTemp_C_1
##     0     7  <NA> 
## 70344 20538     0 
## Flag_EXOCond_uScm_1
##     0     7  <NA> 
## 70344 20538     0 
## Flag_EXOSpCond_uScm_1
##     0     3     7  <NA> 
## 70343     1 20538     0 
## Flag_EXOTDS_mgL_1
##     0     7  <NA> 
## 70344 20538     0 
## Flag_EXODOsat_percent_1
##     0     7  <NA> 
## 70117 20765     0 
## Flag_EXODO_mgL_1
##     0     7  <NA> 
## 70117 20765     0 
## Flag_EXOChla_RFU_1
##     0     2     7  <NA> 
## 70293    51 20538     0 
## Flag_EXOChla_ugL_1
##     0     2     3     6     7  <NA> 
## 45037    51   807 24449 20538     0 
## Flag_EXOBGAPC_RFU_1
##     0     2     3     7  <NA> 
## 50928     2 19414 20538     0 
## Flag_EXOBGAPC_ugL_1
##     0     2     3     6     7  <NA> 
## 18800     2 33701 17841 20538     0 
## Flag_EXOfDOM_RFU_1
##     0     2     3     7  <NA> 
## 70334     9     1 20538     0 
## Flag_EXOfDOM_QSU_1
##     0     2     3     7  <NA> 
## 70334     9     1 20538     0 
## Flag_EXOPressure_psi_1
##     0     2     7  <NA> 
## 70301    43 20538     0 
## Flag_EXODepth_m_1
##     0     2     7  <NA> 
## 70300    44 20538     0 
## Flag_EXOBattery_V_1
##     0     7  <NA> 
## 70344 20538     0 
## Flag_EXOCablepower_V_1
##     0     7  <NA> 
## 70344 20538     0 
## Flag_EXOWiper_V_1
##     0     1     7  <NA> 
## 36975 16543 37364     0 
## Flag_EXOTemp_C_9
##     0     7  <NA> 
## 69794 21088     0 
## Flag_EXOCond_uScm_9
##     0     7  <NA> 
## 69794 21088     0 
## Flag_EXOSpCond_uScm_9
##     0     7  <NA> 
## 69794 21088     0 
## Flag_EXOTDS_mgL_9
##     0     7  <NA> 
## 69794 21088     0 
## Flag_EXODOsat_percent_9
##     0     2     7  <NA> 
## 69587     2 21293     0 
## Flag_EXODO_mgL_9
##     0     7  <NA> 
## 69589 21293     0 
## Flag_EXOfDOM_RFU_9
##     0     2     7  <NA> 
## 69788     6 21088     0 
## Flag_EXOfDOM_QSU_9
##     0     2     7  <NA> 
## 69788     6 21088     0 
## Flag_EXOPressure_psi_9
##     0     7  <NA> 
## 69794 21088     0 
## Flag_EXODepth_m_9
##     0     7  <NA> 
## 69794 21088     0 
## Flag_EXOBattery_V_9
##     0     7  <NA> 
## 69794 21088     0 
## Flag_EXOCablepower_V_9
##     0     7  <NA> 
## 69794 21088     0 
## Flag_EXOWiper_V_9
##     0     1     7  <NA> 
## 65199  4595 21088     0 
## Flag_LvlPressure_psi_13
##     0     7  <NA> 
## 86251  4631     0 
## Flag_LvlTemp_C_13
##     0     7  <NA> 
## 86251  4631     0

Information for EDI methods text

This is information that is included in the methods file for EDI

The minimum water level for CCR was 17.6779275 and the maximum water depth was 19.6358085.

The median water level was 18.612661 and the mean water level was 18.690032.

QAQC Plots

Temperature

Thermistor 1 There will be large gaps where the thermistor is out of the water

Check out the Depth sensor and EXO

EXO Depth at 1.5m

EXO Depth at 9m

EXO DO at 1.5m

EXO DO at 9m

EXO Chla ugL at 1.5m

EXO Chla RFU at 1.5m

EXO Phyco RFU

EXO Phyco ugL

EXO fDOM at 1.5m

EXO fDOM at 9m

EXO Conductivity Sensor at 1.5m

EXO Conductivity Sensor at 9m